USE [MusicExplorer];
GO

DELETE FROM WEB_REPOSITORY;

DELETE FROM REF_TYPE_ARTIST;
INSERT INTO REF_TYPE_ARTIST
SELECT '9A302625-D1A0-4997-BA07-A96410ACF4B9', 'Original' UNION
SELECT '80D67279-53F7-458C-B8F3-5034089378A3', 'Remixer';

DELETE FROM REF_TYPE_WEB_REPOSITORY;
INSERT INTO REF_TYPE_WEB_REPOSITORY
SELECT 'E6B468E5-8E8F-451C-9EF5-C1BFF45A1C28', 'MusicStore', 'Music Store' UNION
SELECT '01EEE2D6-4888-4D50-8448-47B7C98AC8C6', 'WebsiteDatabase', 'Website Database' UNION
SELECT 'FA84AC9A-4070-4EE8-A4D7-F9A395F65D6A', 'YoutubeChannel', 'Youtube Channel' UNION
SELECT 'C6D8B9FF-A9E1-4FB1-BFCB-C7E710E714B7', 'SoundcloudAccount', 'Soundcloud Account';

INSERT INTO WEB_REPOSITORY
SELECT 'E0C666DA-229A-4D92-A5DB-701CECCDA5FE', 'FavoriteTracksWebRepository', 'Favorite tracks', null, 1, 1 UNION
SELECT '4F3851FB-5C03-4898-8377-AF2FA21C1697', 'BeatportWebRepository', 'Beatport', 'E6B468E5-8E8F-451C-9EF5-C1BFF45A1C28', 1, 1 UNION
SELECT '9DA29C2D-3CB4-41E4-BA4D-81DF5FA0DBBE', 'TrackitdownWebRepository', 'Trackitdown', 'E6B468E5-8E8F-451C-9EF5-C1BFF45A1C28', 1, 2 UNION
SELECT '3D06D0C3-E2AD-446A-8025-E62907D3A9EC', 'WorldofhouseWebRepository', 'WorldOfHouse', '01EEE2D6-4888-4D50-8448-47B7C98AC8C6', 1, 1;